Separating Auxiliary Arity Hierarchy of First-order Incremental Evaluation Using (3k+1)-ary Input Relations

نویسندگان

  • Guozhu Dong
  • Louxin Zhang
چکیده

1 The Main Result A rst-order incremental evaluation system (foies) uses rst-order queries to maintain a database view which is deened by a non-rst-order query; some auxiliary relations (views) may also need to be maintained similarly. In 7] it was shown that using (k?1)-ary auxiliary relations is strictly less powerful than using k-ary ones, using a reduction to a result by Cai 3] on help bits. However, that separation was achieved using queries having input relations of arity at least 6k. In this note we improve the separation result by reducing the arity of the input relations of the queries to 3k + 1. (Some necessary background knowledge is given in the next section.)

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Arity Bounds in First-Order Incremental Evaluation and Definition of Polynomial Time Database Queries

After inserting a tuple into or deleting a tuple from a database, a firstorder incremental evaluation system (or a ``foies'') for a database query derives the new query answer by using a first-order query on the new database, the old answer, and perhaps some stored auxiliary relations. Moreover, the auxiliary relations must also be maintained similarly using first-order queries. In this paper w...

متن کامل

Incremental Recomputation of Recursive Queries with Nested Sets and Aggregate Functions

We examine the power of incremental evaluation systems that use an SQL-like language formaintaining recursively-de ned views. We show that recursive queries such as transitive closure,and \alternating paths" can be incrementally maintained in a nested relational language, whensome auxiliary relations are allowed. In the presence of aggregate functions, even more queries canbe ma...

متن کامل

On the Power of Incremental Evaluation in SQL-Like Languages

We consider IES(SQL), the incremental evaluation system over an SQL-like language with grouping, arithmetics, and aggregation. We show that every second order query is in IES(SQL) and that there are PSPACE-complete queries in IES(SQL). We further show that every PSPACE query is in IES(SQL) augmented with a deterministic transitive closure operator. Lastly, we consider ordered databases and prov...

متن کامل

The Expressive Power of k-ary Exclusion Logic

In this paper we study the expressive power of k-ary exclusion logic, EXC[k], that is obtained by extending first order logic with k-ary exclusion atoms. It is known that without arity bounds exclusion logic is equivalent with dependence logic. From the translations between them we see that the expressive power of EXC[k] lies in between k-ary and (k+1)-ary dependence logics. We will show that, ...

متن کامل

SQL Can Maintain Polynomial-Hierarchy Queries

1 Summary Let us introduce the concept of an incremental evaluation system, or IES, discussed in 15]. Suppose we have a query Q : S ! T. An IES(L) for maintaining the query Q is a system consisting of input database I, an answer database A, an optional auxiliary database, and a nite set of \update" functions that correspond to the diierent kinds of permissible update to the input database. Thes...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 1997